Linked table being deleted and created locally??

[sammylou]

I have just split my multi-user DB into Front end and back end. All appears fine apart from there is code in the autoexec module that checks to see if a particular table has been updated today. Basically the first person to login to the DB each day will run this procedure without realising. Now I have FE & BE however, because the query used by the autoexec module is a "Make table" query rather than delete all data and use an append query, every person logging in is running the update each day if it is the first time they have logged in on their PC and they are getting a local table on each of their computers. Is there any code that will create the table in the networked location (when the first person of the day logs in), rather than me having to change all my "delete table" queries to cleardown data and then re-append updated data?

There are quite a lot of delete queries in my DB and I am now worried that I shouldn't have split the DB as I may have caused myself loads of work which I don't have time to do.

I have looked on other threads but cannot find the answer and would greatly appreciate some help

 

[sammylou]

thanks for your help. Unfortunately I cannot locate this Help file in Access, I have even expanded all of the Help files.

Additionally I now have a problem whereby one member of staff who uses a laptop to connect to the network drive, cannot use the same FE as everyone else. This is because the networked drive has a different name on her PC. I have tried 3 different ways of creating a unique FE for her. If I try and change the linked tables when at her PC using her FE, it wants me to point to the correct path for each table in the DB and there are 100+ of them. I cannot find a way of selecting all of them and pointing at the right directory once, it asks me everytime for every table!

If I create a new FE for her and import everything (except linked tables) from the generic FE, and then use the Linked table manager to create the linked tables then it doesn't compile properly, even though I have double checked the VB references to make sure they are the same?

I am now about to give up and tell her she cannot have access to the DB. Please help. Thanks

 

[sammylou]

Again thanks for your help, however I must have some help files missing because I have looked under "Creating and working with Databases and Objects folder" but I don't have "Database objects" + "Queries" + "Microsoft Jet SQL Reference" folder??

I have also tryed searching by using a Jet SQL keyword such as "WHERE" but this brings back nothing.

Do I need the systems people to add some missing help files or can I download this myself? The problem here is that the people who look after the PCs and software admit that they know nothing about Access!!

I am using Access 2002 SP3

 

[sammylou]

I am assuming you mean the tab page "contents" under help? If this is correct then the topic is definately not under there.

If "Table of contents" is something else than the Help menu at the top, then I have no idea where it is, I have looked under all the menus and cannot see anything called this

 

[sammylou]

Thank You very much for all your help. I can now see that I have 3 help files missing including the JET SQL reference one, although I have now located the .chm file on my C:\drive.

I am assuming now though that I need to replace all my "Make Table" Queries in the FE DB with modules showing "SELECT...INTO statements" It might be quicker to just delete the data in each table first and change the Make Table" queries to "Append" queries?

 

[sammylou]

I am using Access 2002. Thanks again for all your help. My systems people have now put the missing help files in place!