Search results for query: *

Hi, does anyone know how to copy a Tables sturcture using SQL?!?!?!

I have tried leaving the target DB open when i run the main DB, but still not luck. Thing is, this DB has been working perfectly right up until a few days before new year! would this have anything to do with the problem??

Hey, I have a database that tracks and logs all work that we have in our department. when i try to save a record a runtime error '3197' appears, and when i click debug the following code is highlighted: DoCmd.TransferDatabase acExport, _ "Microsoft Access", _ "R:\Jobs...

Sorry, i missed out the last line of the error, the code is: DoCmd.TransferDatabase acExport, _ "Microsoft Access", _ "R:\HCP Finance Jobs Database\BACKUP.MDB", _ acTable, _ "TblJobList", _ "Backup_" & Format(Date, "mmddyyyy") & "_" & Format(time, "hhmmss")

Hey, Yes, i tried putting both the databses on my desktop and change the code to the new location for the backup and for some reason, exactly the same error comes up! (with exception for a different path, which now referes to the desktop location). The backup database works perfectly... alone...

I have ajobs database that tracks and logs all jobs. A database called 'backup' has been created which backups all the neccessary data. Now, when i save a form on the jobs database a runtime error '3044' appears saying "r:\job\backup.mdb isnt a valid path. Make sure th path is spelled correctly...

Great Thanks alot for all your contributions! They were all very helpful.

We have a multi user database system, and every now and then we need to perform maintainance on the database. It can only be done when no one is in the database. Is there any way of "booting out" these users by creating a button for admin users?

I have a login screen created by the follwing VBA coding on the command button: Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo box If IsNull(Me.cboEmployee) Or Me.cboEmployee = "" Then MsgBox "You must enter a User Name.", vbOKOnly...

I have a multi user DB with no login at the moment. There are 2 types of users, Admin (3 members of staff) Users (40+ staff). I would like for the users to input their personal login details and once accepted, for one form to automatically open and maximise (Request_form) but dont want them to...

Thanks alot for your help lupins46. You advice was very helpful.

I have a multi user DBMS on a windows 98 machine. Some of the users on the LAN have Windows XP with Access XP installed. Each time these users access the database from their machines, a dialogue box appears saying that the user has an older version of Access and tries to upgrade it. As most of...