Recent content by supportt

Reply Yes, users do have there own copy of the front-end from the split. I will check the tables to see if there is any bad records. But, I don't think that will be it, because every time the db gets corrupt, I just replace with a fresh copy. This is a new db, so there really is no records in...

Reply Are you referring to splitting the database, if so? I did that and still had the problem...any thoughts on the version differences? Thanks

Reply for setup The mdb file is on the server and it is shared out to the network users. It is just a shortcut pointing to the mdb file. thanks

Reply for single user The original setup was just one pc and I did not see any problems at all....

I am trying to trouble-shoot an issue with a Access 2002 database. Basically I have the database file shared out on a local network and there are 4 users accessing it. Well, there are using Access 2003 when opening the db file, but every time they exit the db, it is getting corrupted beyond...

I finally got it :) Thanks Pat and RGUY, this was the problem, my destination table, column PRO_NUMBER was not set to AUTONUMBER and my DUMMY SOURCE TABLE, the PRO_NUMBER was set to AUTONUMBER, so before I ran my append query I was not able to edit the PRO_NUMBER in the DUMMY table to the...

thanks for the advise :( Well, the first link is a little advanced for me, I am a bit new to access. The second link sounds more like what I did the first go round and it worked then, but can't seem to get it to work now. Basically what I did was: Enter a dummy record in my first table, it...

wondering if you were able to look at the db just wanted to follow-up

wondering if you were able to look at the db just wanted to follow-up

sorry, wrong url here is the correct one http://www.medicallasers.cc/test/transitsolutions.zip

No luck with the copy idea I tried to copy tables/forms and put them in a new db, but got all kinds of errors. What if you download the db from here: http://www.medicallasers.cc/golf/transitsolutions.zip If not, I can try to create a new db with some of the functions Let me know thanks ;)

Suggestion Any chance I can attach the access db? So you could have a look, it is only 2mb zipped up... thanks David

that seems to be a little much my process was working fine, but it has been a while since I messed with the database. So, I really don't want to re-envent wheel at this point....but I do appreciate the additional options. I think my original was just real simple, but I know I am just missing...

Well, maybe I missed something, that did not work This is what I have, I have a query called auto_number_append and it is suppose to append one record to a table called auto_number, but when I run it, it is not appending a record. The auto_number table is empty before I run the...

Thanks I will give it a try... thanks again