Recent content by seanog2001

i am using access 2007 basically all i want to do is set up the database so users can use it but they can only see the forms/GUI's i have created.

Hi, i dont know if i am posting this in the right forum but i have a completed access database it consists of forms and querys. i just want to know can i make this database an executable file so when i click on it just the forms will appear on screen so the user can navigate through the forms?

hi, i have a basic database and i want to link it to a microsoft sql server via ODBC how do i create a odbc file?

Hi all, Just wondering is it possible to create a login in box in access with different user levels(ie one user has access to all forms whereas other users have limited access) Do i need to do some VB programming to grant the different access levels?

If your tables are currently in Access you need to open up SQL and import them in SQL. Then switch back to Access and use the link table manager to link them using ODBC() types. Point to the sql server database and select the tables. You may also need to create a DNS connection first so that you...

Hi, I am trying to link tables in my access database to an Sql Server (microsoft sql server 2005) does anyone know how i would go about this? or where i could find info on how to link the tables? Basically i want to have my access database tables stored on the sql server

Hi, i have a fairly large access database i want to transfer to SQl and eventually on to an sql server does anyone know how i would go about doing this. Cheers

how do i do this

can i set multiple usenames and passwords

I designing an access DB and just wanted to know how i put a username & password protection on it. any help?

cheers guys

ive areport with alot of data and it loks messy ast the mo how do i tidy it up so it looks more professional it all squashe donto 1pg at the mo fields r been cut short etc how do i extend it to two pages r even keep it all on on e pg but it looks professional

I want to create a report where it will generated details on data in my db Dependant on a data enter by the user.

hi all, I have a form which allows users to add and edit details about shop stores, it has all different kinds of info on these stores, name address etc what i need help with is, a store can have a number of cash registers in there store, from one to 10, it can also have inactive registers...

cant find it mate