New to thsi Frontend Backend Access Developing

[simeybt]

All,

I’m pretty new to fronted backend access development and I’m running into a few problem. I have set up a form that reads all the correct information from the backend database(the only thing in my backend is the source tables nothing else) This works fine and it pulls back the information correctly. But I want now to use the information I have pulled back to create a new record into the backend Database table. But when I run the code nothing happens, it seems to run ok but no records get added to the backend database. is there anything I need to do to be able to do additions, deletions, insertions. I am using VBA code for all the commands.

Any help or pointers would be great

Simon

 

[willir]

Simon

Using code to connect to the backend is fine. But you have to make sure your cursor has "write" permission.

An alternative would be to link the tables using the link manager. This is a less secure option, but ig makes it seem like your backend is part of your front end.


Go to the table management section / tab of your database and select "New", and then select "Link..." Or use the Link table manager from the tools menu.

Richard

 

[simeybt]

I am currently using the link method your have described. Would you suggest to use the another way to connect to your backend database i.e. using ADO/OLEDB.

Simon

 

[willir]

Simon, it depends on your needs. Lot more coding to have to create and break connections, but is more secure.

If you are using linked tables, and you are not seeing data, how are you adding the data? Have you tried using a form? A query? Or code?

It is okay for you to create a test table on the backend and try to update it through the front end. Many of us work with linked tables without the problem described.

Shows us the code in question.

Hint: A common mistake is not to include the UPDATE statment after editing or adding the record. For example:

Assumption: RST is a record set object

With rst
  .addnew
  !MyPKey = MyUniqueCode
  !TransDate = DATE()
  !curAmount = curTransAmount
  .update
End With

Without the UPDATE statement, nothing happens. But this is not an issue caused by linking tables.

Richard

 

[simeybt]

Hi all Again!!,

I now want to password protect my system so i've passed a password on the backend database, but yes to gussed my forms can't link to the backend anymore because the database is protected. If i relink the tables and enter the password they work ok. But i dont want this as if defeats the need for the security. So a pointer on how to secure the backend of the database so the users has to enter the infromation in the frontend every time they run the application.

Thanks In Advance

Simon

 

[psemianonymous]

I give a decent overview of what's available, security-wise, in Access here:

Gauging your security needs; alternatives to Access/JET security faq181-3893


If you do need to secure your data from your users, use the built-in Access/JET security module (not the database password). The best introduction to this is found:

http://www.abcdataworks.com/security.htm

It will take a while to learn how it all works, but once you set it up, it's easy to use.


Pete