Search results for query: *

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

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...

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...

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...

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...