Private Sub ShipmentRequest_Click()
Dim DB As Database
Dim rst As DAO.Recordset
Set DB = DBEngine(0).OpenDatabase("\\Backup\hosted files\CustomerDatabase\
customerdbnew.mdb")
Set rst = DB.OpenRecordset("Customer Number", dbOpenDynaset)
End Sub
This code gives me the error
run-time error '3078':
The microsoft jet database engine cannot find the input table or query
'customer number'. Make sure it exists and that its name is spelled correctly.
The table does exist, and it is spelled correctly, any ideas of how to solve
this?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200508/1